# -*- encoding:utf-8 -*-
"""
@作者：ven
@文件名：base_worker_info.py
@时间：2021-08-11  16:11
@文档说明:
"""
import json

from common.ConnMysql import ConnMysql


def base_work_info():
    workerList = []
    sql = 'select u_id,name,worker_sn from base_worker_info where del_flag=0'

    for item in json.loads( ConnMysql().select_tb(sql)):
        workerList.append({'u_id':item[0],'name':item[1],'worker_sn':item[2]})
    return workerList

if __name__ == '__main__':
    base_work_info()